with open('cquCollege.txt', 'r') as f:
    data = f.read()
lines = data.split('\n')

for line in lines:
    res = line.split(' ')
    res = [r for r in res if r!= '']
    id = res[0][1:-1]
    school = res[1]
    college = res[2]
    major = res[3]
    print(f"INSERT INTO `app_schoolcollegemajor` (`id`, `school`, `college`, `major`) VALUES ({id}, {school}, {college}, {major});")
